/*
Navicat MySQL Data Transfer

Source Server         : mysql_252
Source Server Version : 50516
Source Host           : localhost:3306
Source Database       : xmxdb

Target Server Type    : MYSQL
Target Server Version : 50516
File Encoding         : 65001

Date: 2012-07-09 09:26:44
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `tbl_sys_user`
-- ----------------------------
DROP TABLE IF EXISTS `tbl_sys_user`;
CREATE TABLE `tbl_sys_user` (
`userID`  varchar(14) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '八位日期+六位流水号（yyyyMMdd000001）' ,
`userName`  varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`passWord`  varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`email`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`phone`  varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`userID`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of tbl_sys_user
-- ----------------------------
BEGIN;
INSERT INTO `tbl_sys_user` VALUES ('20120625000001', 'admin', '123456', 'xiamx@zteits.com', '18661023486');
COMMIT;

-- ----------------------------
-- Indexes structure for table tbl_sys_user
-- ----------------------------
CREATE UNIQUE INDEX `PK_SYS_USER_UID` ON `tbl_sys_user`(`userID`) USING BTREE ;
CREATE UNIQUE INDEX `IDX_SYS_USER_UNAME` ON `tbl_sys_user`(`userName`) USING BTREE ;
